|
Author |
Thread Statistics | Show CCP posts - 1 post(s) |

Ynot Eyob
Nisroc Angels The Obsidian Front
271
|
Posted - 2012.11.28 11:11:00 -
[1] - Quote
You can find it here:
http://code.google.com/p/temars-eve-api/ Nisroc Angels Nisroc - Angel of Freedom Nisroc is known as "The Great Eagle".
|

Ynot Eyob
Nisroc Angels The Obsidian Front
369
|
Posted - 2013.08.26 08:07:00 -
[2] - Quote
When you run a standard check it takes 100 at a time, and you can see the Progress.
Would this be posible for the full reset check as well.
Im constantly getting a error 500 when running the full reset check, and it stops. This Means i have a number of people not getting updated with right Corp / Alliance tags and nore get their Avatar updated.
Else great work, keeping the mod running Nisroc Angels - The Obsidian Front Nisroc - Angel of Freedom Nisroc is known as "The Great Eagle".
|

Ynot Eyob
Nisroc Angels The Obsidian Front
369
|
Posted - 2013.08.26 10:58:00 -
[3] - Quote
Shin Chogan wrote:Ynot Eyob wrote:When you run a standard check it takes 100 at a time, and you can see the Progress.
Not sure what you mean by this ... the cron job runs as many as it can in an allotted time period.
Via SMF you have two options for checks. A simpel which takes 100 members at a time and update on screen so you can see Progress and a full reset, which you need if you change theme and want bigger avatars, or someone update their avatar in EVE, and you wana transfer that to the forum.
This Reset check takes all member at once which result tin a timeout and server 500 error. Nisroc Angels - The Obsidian Front Nisroc - Angel of Freedom Nisroc is known as "The Great Eagle".
|

Ynot Eyob
Nisroc Angels The Obsidian Front
369
|
Posted - 2013.08.26 13:12:00 -
[4] - Quote
On page 26 i belive in this forum :p Nisroc Angels - The Obsidian Front Nisroc - Angel of Freedom Nisroc is known as "The Great Eagle".
|

Ynot Eyob
Nisroc Angels The Obsidian Front
369
|
Posted - 2013.08.27 07:19:00 -
[5] - Quote
Im running Windows 2003 Server IIS But ill check the log there, its never been an issues before. Nisroc Angels - The Obsidian Front Nisroc - Angel of Freedom Nisroc is known as "The Great Eagle".
|

Ynot Eyob
Nisroc Angels The Obsidian Front
369
|
Posted - 2013.08.27 07:31:00 -
[6] - Quote
Well this is a bit bull.
Nothing in Windows Event Log Only error 500 in the IIS Log, but no indication of what is failing. Does PHP have its on log file? Nisroc Angels - The Obsidian Front Nisroc - Angel of Freedom Nisroc is known as "The Great Eagle".
|

Ynot Eyob
Nisroc Angels The Obsidian Front
369
|
Posted - 2013.08.27 07:32:00 -
[7] - Quote
Shin Chogan wrote:Ynot Eyob wrote:Shin Chogan wrote:Ynot Eyob wrote:When you run a standard check it takes 100 at a time, and you can see the Progress.
Not sure what you mean by this ... the cron job runs as many as it can in an allotted time period. Via SMF you have two options for checks. A simpel which takes 100 members at a time and update on screen so you can see Progress and a full reset, which you need if you change theme and want bigger avatars, or someone update their avatar in EVE, and you wana transfer that to the forum. This Reset check takes all member at once which result tin a timeout and server 500 error. Just to ensure we are on the same page you mean the 2 options : Run Full Member Check Now Reset All Names, Avatars to those Set with Main Character and the 2nd one is the one that is causing the error ? If this is the case then it does no API fetching at all ... and error 500 is a server error ... can you get me what is in your apache error logs when you get this ?
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 File: XXXXXXX\TEA.php Line: 2408
Nisroc Angels - The Obsidian Front Nisroc - Angel of Freedom Nisroc is known as "The Great Eagle".
|

Ynot Eyob
Nisroc Angels The Obsidian Front
369
|
Posted - 2013.08.27 08:40:00 -
[8] - Quote
Server Windows 2003 IIS 6 MySQL 5 PHP 5
TEA Your Version: 1.3.0 r179
SMF 2.0.5
I just updated the SMF Database to 2.0.5 as it was 2.0.2 but that didnt help.
Are the old TEA files from 169 cashed somewhere? Iv look at the TEA fil and the line its reffering to seems to be commented out.
Im clicking on: Reset All Names, Avatars to those Set with Main Character
The other Works. Nisroc Angels - The Obsidian Front Nisroc - Angel of Freedom Nisroc is known as "The Great Eagle".
|

Ynot Eyob
Nisroc Angels The Obsidian Front
369
|
Posted - 2013.08.27 08:45:00 -
[9] - Quote
Im clicking on: Reset All Names, Avatars to those Set with Main Character Nisroc Angels - The Obsidian Front Nisroc - Angel of Freedom Nisroc is known as "The Great Eagle".
|

Ynot Eyob
Nisroc Angels The Obsidian Front
369
|
Posted - 2013.08.27 08:55:00 -
[10] - Quote
Sorry this error is new
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 File: XXXXXX\TEA.php Line: 2408
Thats when clicking First link as you wrote. Run Full Member Check Now
The other link just come with a error 500 still but with noting in any error logs. Nisroc Angels - The Obsidian Front Nisroc - Angel of Freedom Nisroc is known as "The Great Eagle".
|
|

Ynot Eyob
Nisroc Angels The Obsidian Front
369
|
Posted - 2013.08.27 08:56:00 -
[11] - Quote
http://forum.obsidianfront.com/index.php?action=admin;area=tea;sa=checks;e7646657677b=ebe53c82584b7212f400f445ac1f95ae
Nisroc Angels - The Obsidian Front Nisroc - Angel of Freedom Nisroc is known as "The Great Eagle".
|

Ynot Eyob
Nisroc Angels The Obsidian Front
369
|
Posted - 2013.08.27 09:33:00 -
[12] - Quote
Right so i found a log file:
http://forum.obsidianfront.com/index.php?action=admin;area=tea;sa=checks;resetApply Filter: Only show the errors with the same message 8: Undefined variable: nameApply Filter: Only show the errors from this fileFile: C:/XXXXX/Sources/TEA.php Line: 2736
And
Apply Filter: Only show the error messages of this URLhttp://forum.obsidianfront.com/index.php?action=admin;area=tea;sa=checks;resetApply Filter: Only show the errors with the same message 8: Undefined variable: countApply Filter: Only show the errors from this fileFile: C:/XXXXXX/Sources/TEA.php Line: 2799 Nisroc Angels - The Obsidian Front Nisroc - Angel of Freedom Nisroc is known as "The Great Eagle".
|

Ynot Eyob
Nisroc Angels The Obsidian Front
369
|
Posted - 2013.08.27 11:22:00 -
[13] - Quote
Ty,
Iv walked trough the database, and no Realnames was empty
Im still getting the same errors.
I think if i could fix this:
Check Full Member Now
With the error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 File: C:\XXXXXXX\TEA.php Line: 2408
It might solve the rest.
Line 2408: $users1 = $this -> smcFunc['db_query']('', "SELECT id_member, member_name, ID_GROUP FROM {db_prefix}members WHERE id_member <= ".$this -> lastid);
What i dont understant, but yet again im a .NET programmer not a php programmer, if i make an Echo on $this i get this: API System Screwed : bool(false)
Now how would that fit in with "Where id_member <="
Would this mean, that im not getting an ID from the API, and it cannot compare and string with an integer?
This would then make sence with the error 500.
And then my last question would be, 169 worked, so if it cant pull an API now, whats changes from 169 that could make this happen.
Nisroc Angels - The Obsidian Front Nisroc - Angel of Freedom Nisroc is known as "The Great Eagle".
|

Ynot Eyob
Nisroc Angels The Obsidian Front
369
|
Posted - 2013.08.27 11:37:00 -
[14] - Quote
Iv looked at the cron job log, and i can see this no longer constact the API eighter.. Grrrr Nisroc Angels - The Obsidian Front Nisroc - Angel of Freedom Nisroc is known as "The Great Eagle".
|

Ynot Eyob
Nisroc Angels The Obsidian Front
369
|
Posted - 2013.08.27 11:39:00 -
[15] - Quote
Shin Chogan
If we can posible solve this together, at some point once im home from Work, ill trow two plex your way for your work. Nisroc Angels - The Obsidian Front Nisroc - Angel of Freedom Nisroc is known as "The Great Eagle".
|

Ynot Eyob
Nisroc Angels The Obsidian Front
369
|
Posted - 2013.08.27 12:29:00 -
[16] - Quote
Iv changed directly from 169 to yours 179
The old 169 i changed the TEAP to use https and that worked without issues.
PHP Version 5.2.17
cURL is installed
curl cURL support enabled cURL Information libcurl/7.21.0 OpenSSL/0.9.8q zlib/1.2.3
Your new version made no different
$Echo .$this API System Screwed : bool(false)
With the new version. I deleted all old TEA files before installing this.
I know dont fix what aint broken :p Nisroc Angels - The Obsidian Front Nisroc - Angel of Freedom Nisroc is known as "The Great Eagle".
|

Ynot Eyob
Nisroc Angels The Obsidian Front
369
|
Posted - 2013.08.27 12:55:00 -
[17] - Quote
bool(false)
This forum might not be the best to finish this Nisroc Angels - The Obsidian Front Nisroc - Angel of Freedom Nisroc is known as "The Great Eagle".
|

Ynot Eyob
Nisroc Angels The Obsidian Front
369
|
Posted - 2013.08.27 15:54:00 -
[18] - Quote
None of abov helpped same issue
Biggest problem now is that people cant registre on the forum anymore. They can put in their Id and vCode cut cant choose a character.
Im woundering what version of php you have used for version 179 Nisroc Angels - The Obsidian Front Nisroc - Angel of Freedom Nisroc is known as "The Great Eagle".
|

Ynot Eyob
Nisroc Angels The Obsidian Front
369
|
Posted - 2013.08.28 08:54:00 -
[19] - Quote
Well iv updated to the latest version of PHP allowed on Windows 2003.
This is what i get now: API System Screwed - Can't fetch Toons : bool(false)
curl is running the new version also:
curl
Quote:cURL support enabled cURL Information 7.30.0 Age 3 Features AsynchDNS Yes Debug No GSS-Negotiate Yes IDN No IPv6 Yes Largefile Yes NTLM Yes SPNEGO Yes SSL Yes SSPI Yes krb4 No libz Yes CharConv No Protocols dict, file, ftp, ftps, gopher, http, https, imap, imaps, ldap, pop3, pop3s, rtsp, scp, sftp, smtp, smtps, telnet, tftp Host i386-pc-win32 SSL Version OpenSSL/0.9.8y ZLib Version 1.2.7 libSSH Version libssh2/1.4.2
I got you eve-mail last night, and this will be posible. Im tempted to return to 169 for now, so at least people can register on our forum. Im our of idears Nisroc Angels - The Obsidian Front Nisroc - Angel of Freedom Nisroc is known as "The Great Eagle".
|

Ynot Eyob
Nisroc Angels The Obsidian Front
369
|
Posted - 2013.08.28 09:23:00 -
[20] - Quote
Worse past is i hade to make a role back on the PHP version also, as about 10 other sites crashed on the strtotime compared with date.timestamp. Fx 5 killboards....
Trying to find 169 again Nisroc Angels - The Obsidian Front Nisroc - Angel of Freedom Nisroc is known as "The Great Eagle".
|
|

Ynot Eyob
Nisroc Angels The Obsidian Front
369
|
Posted - 2013.08.28 09:40:00 -
[21] - Quote
Dude, you should make a new topic called TEA
And state that donation is accepted, i will deffently donate something for your effort Nisroc Angels - The Obsidian Front Nisroc - Angel of Freedom Nisroc is known as "The Great Eagle".
|

Ynot Eyob
Nisroc Angels The Obsidian Front
369
|
Posted - 2013.08.29 14:17:00 -
[22] - Quote
So reinstalled 169 Again, and made the changes as before.
Now i just get an API error.
Iv made a test SMF install blank to play around with. Here is the funny part. Iv installed the newest cURL and i made a test script, first on Google news RSS and then directly on
https://api.eveonline.com/account/APIKeyInfo.xml.aspx?keyID=XXXXX&vCode=XXXXX
Googles RSS print out fine but the account API shows nothing, not even an error just blank. This is the script i used as test:
http://stackoverflow.com/questions/181082/how-do-i-install-curl-on-windows part 2
Unless CCP have blocked my server for API calls, im out of idears, it only runs one killboard and one SMF forum so nothing API heavy calling, oh and an ingame .NET application, which actually works well. Now i should be right, by saying that cURL should print out the XML from the API Nisroc Angels - The Obsidian Front Nisroc - Angel of Freedom Nisroc is known as "The Great Eagle".
|

Ynot Eyob
Nisroc Angels The Obsidian Front
369
|
Posted - 2013.08.29 14:28:00 -
[23] - Quote
nm, finally got it to Work Again with 169 \o/
I serious get anoind when people hardcode adresses into the code, i missed 3 Places in TEAP with https changes, only changed the one constant at the very top exspecting that to Work trough out the code. Nisroc Angels - The Obsidian Front Nisroc - Angel of Freedom Nisroc is known as "The Great Eagle".
|

Ynot Eyob
Nisroc Angels The Obsidian Front
369
|
Posted - 2013.09.25 11:17:00 -
[24] - Quote
Iv found a huge issue with curl, Windows server and php.ini
Script execution timeout is default 60 sec in php.ini on Windows servers. Problem is, if you have more than 100 members which curl make a check up on, it doesnt manage to finish in those 60 sec.
Iv fix this problem by ajust the php.ini and set the execute timeout to 240 sec. This can handle over 500 api calls and avatar downloads. Just a heads up.
As im no php programmer i wouldnt know this, but i belive its posible in the TEPAC to set the excution timeout to 240 before running the script, for those who cant ajust the php.ini file. Nisroc Angels - The Obsidian Front Nisroc - Angel of Freedom Nisroc is known as "The Great Eagle".
|

Ynot Eyob
Nisroc Angels The Obsidian Front
369
|
Posted - 2013.09.25 11:21:00 -
[25] - Quote
Shin Chogan
If you like a full Windows based test site to Work on with full access to what you need let me know. I think some of the issues i read about here, might be caused by the php on Windows version. Nisroc Angels - The Obsidian Front Nisroc - Angel of Freedom Nisroc is known as "The Great Eagle".
|

Ynot Eyob
Nisroc Angels The Obsidian Front
370
|
Posted - 2013.10.11 06:39:00 -
[26] - Quote
What does skills have to do with this plugin to control a forum access? Nisroc Angels - The Obsidian Front Nisroc - Angel of Freedom Nisroc is known as "The Great Eagle".
|

Ynot Eyob
Nisroc Angels The Obsidian Front
370
|
Posted - 2013.10.11 07:30:00 -
[27] - Quote
Ah must be in the newer version Nisroc Angels - The Obsidian Front Nisroc - Angel of Freedom Nisroc is known as "The Great Eagle".
|
|
|
|